﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_BaskOrderLog') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_BaskOrderLog
END
GO
create view V_BaskOrderLog
as select 
[Guid]
,[MemLoginID]
,[ProductGuid]
,[Title]
,[Content]
,[CreateTime]
,[CreateUser]
from [ShopNum1_BaskOrder_Log] where [IsDeleted]=0